﻿using System;

namespace RH.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// </summary>
        public static class SP
        {
            //NOTE: ** Means Implemented in MySQL
            public const String GET_PAGED_PRODUCTS_BY_COMPANY = "GetPagedProductsByCompany";
            public const String GET_PAGED_PRODUCTS_BY_CATEGORY = "GetPagedProductsByCategory"; //** 
            public const String GET_CONTACTS_BY_COMPANY = "GetContactsByCompany";
            public const String GET_USERS_BY_COMPANY = "GetUsersByCompany";
            public const String GET_PRODUCT_RANDOMLY = "GetPagedRandomProduct";
            public const String GET_PRODUCT_BY_SEARCH = "GetPagedProductBySearch";
            public const String GET_PRODUCT_POPULAR_SEARCH = "GetPagedProductByPopularSearch";
            public const String GET_USER_FAVORITES = "GetUserFavorites";
            //public const String GET_PRODUCT_BY_LATEST_ADDED = "dbo.GetProductByLatestAdded";

            //public const String GET_PRODUCT_BY_LATEST_UPDATED = "dbo.GetProductByLatestUpdated";
            public const String GET_PRODUCT_BY_DISCOUNT_PRODUCTS = "GetPagedProductByDiscount";
            public const String GET_PRODUCT_BY_SPECIAL_OFFERS = "GetPagedProductBySpecialOffers";

            public const String GET_CONTENT = "GetContentList";
            public const String GET_CATEGORY = "GetCategoryList";
            public const String GET_TOP_VIEWED_PRODUCTS = "GetTopViewedProducts";
            public const String GET_RECENT_PRODUCTS = "GetRecentProducts";
            public const String GET_SIMILAR_PRODUCTS = "GetSimilarProducts"; //**

            public const String GET_STORE_DETAILS = "GetStoreDetails";
            public const String GET_PRODUCTS_BY_ID = "GetProductsByID";
            public const String GET_LOOKUP_DATA = "GetLookupData";

            public const String GET_RECEIVE_DETAILS = "GetReceiveDetails";
            public const String GET_ISSUE_DETAILS = "GetIssueDetails";
            public const String GET_INVENTORY_LIST = "GetPagedInventory";


            //Newly added for RH
            public const String GET_SAVEDSEARCH_LIST = "GetSavedSearchList";
            public const String GET_LEAD_LIST_BY_SERVICE_PERIOD = "GetLeadListByServicePeriod";
            public const String GET_SERVICEPERIOD_SPANS_BY_COMPANY = "GetServicePeriodSpansByCompany";
        }
        public static class Sql
        {
            public const String INDUSTRY_TYPE = "SELECT * FROM IndustryType ORDER BY Name";
        }
        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }
    }
}
